package com.bzframework.pro.constant;

/**
 * @Author bingzhong
 * @Date 2025/3/30 15:16
 * @Description
 */
public interface CommonSqlConstants {

    String fetchCommunicationRecord = "SELECT " +
            "bc.id id, bc.tan_ma_customer_id tanMaCustomerId," +
            "bcr.tan_ma_employee_id salesId," +
            "bcr.content content, bcr.createtime createTime FROM beiya_customer bc " +
            "JOIN beiya_communicate_record bcr ON bc.id = bcr.customer_id";


    /**
     * 协作人
     */
    String fetchCollaboratorsRecord = "SELECT " +
            "bc.id id, bc.tan_ma_customer_id tanMaCustomerId,bc.sale_person_list salePersonList," +
            "bcr.tan_ma_employee_id salesId," +
            "bcr.content content, bcr.createtime createTime FROM beiya_customer bc " +
            "JOIN beiya_communicate_record bcr ON bc.id = bcr.customer_id";



}
